SELECT EXTRACTVALUE( de.family_doctor, 'rd' ) AS ReferredBy,
EXTRACTVALUE( de.family_doctor, 'rdohip' ) AS LicNo,
de.last_name, de.first_name, date_joined AS DateJoined,
CONCAT( "" ,
de.demographic_no, "" ) As Link
FROM demographic de
WHERE LENGTH( EXTRACTVALUE( de.family_doctor, 'rd' )) > 1
AND LOCATE('{referredby}', EXTRACTVALUE( de.family_doctor, 'rd' ) ) > 0
AND date_joined BETWEEN '{start}' AND '{finish}'
ORDER BY EXTRACTVALUE( de.family_doctor, 'rd' ) ;